Tabela PatientTumourCardKRNStatus

Definicja tabeli PatientTumourCardKRNStatus

Name

PatientTumourCardKRNStatus

Code

PatientTumourCardKRNStatus

Comment

Zmiany statusów kart


Lista kolumn tabeli PatientTumourCardKRNStatus

Name

Code

PatientTumourCardKRNStatusID

PatientTumourCardKRNStatusID

PatientTumourCardID

PatientTumourCardID

StatusID

StatusID

StatusChangeDT

StatusChangeDT

StatusInfo

StatusInfo

Active

Active


Kolumna PatientTumourCardKRNStatusID tabeli PatientTumourCardKRNStatus

Definicja kolumny PatientTumourCardKRNStatusID tabeli PatientTumourCardKRNStatus

Name

PatientTumourCardKRNStatusID

Code

PatientTumourCardKRNStatusID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID zmiany statusu karty


Kolumna PatientTumourCardID tabeli PatientTumourCardKRNStatus

Definicja kolumny PatientTumourCardID tabeli PatientTumourCardKRNStatus

Name

PatientTumourCardID

Code

PatientTumourCardID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

karta nowotworu pacjenta


Kolumna StatusID tabeli PatientTumourCardKRNStatus

Definicja kolumny StatusID tabeli PatientTumourCardKRNStatus

Name

StatusID

Code

StatusID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

status karty. Slownik statusów w DictionaryValue, mozliwe statusy: INPROGRESS, ACCEPTED,ACCEPTED_WITH_WARNINGS, REJECTED


Kolumna StatusChangeDT tabeli PatientTumourCardKRNStatus

Definicja kolumny StatusChangeDT tabeli PatientTumourCardKRNStatus

Name

StatusChangeDT

Code

StatusChangeDT

Data Type

DATE

Mandatory

Yes

Comment

data zmiany statusu


Kolumna StatusInfo tabeli PatientTumourCardKRNStatus

Definicja kolumny StatusInfo tabeli PatientTumourCardKRNStatus

Name

StatusInfo

Code

StatusInfo

Data Type

VARCHAR2(1800)

Mandatory

No

Comment

dodatkowe informacje o statusie, np. opis bledu


Kolumna Active tabeli PatientTumourCardKRNStatus

Definicja kolumny Active tabeli PatientTumourCardKRNStatus

Name

Active

Code

Active

Data Type

NUMBER(1)

Mandatory

Yes

Comment

flaga wskazujaca na aktualny status karty


Lista kluczy tabeli PatientTumourCardKRNStatus

Name

Code

Primary

PK_PatientTumourCardStatus

PK_PatientTumourCardStatus

X


Klucz PK_PatientTumourCardStatus tabeli PatientTumourCardKRNStatus

Definicja klucza PK_PatientTumourCardStatus tabeli PatientTumourCardKRNStatus

Name

PK_PatientTumourCardStatus

Code

PK_PatientTumourCardStatus

Primary

Yes

Comment